home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
kermit.columbia.edu
/
kermit.columbia.edu.tar
/
kermit.columbia.edu
/
newsgroups
/
misc.20021006-20030409
/
000223_Christopher.Jones@oracle.comX_Mon Jan 20 10:05:34 EST 2003.msg
< prev
next >
Wrap
Text File
|
2003-04-08
|
4KB
|
117 lines
Article: 14014 of comp.protocols.kermit.misc
Path: newsmaster.cc.columbia.edu!panix!newsfeed.mathworks.com!cyclone.swbell.net!cyclone-sf.pbi.net!216.218.192.242!news.he.net!chekhov.conxion.net!news.oracle.com!not-for-mail
Followup-To: comp.databases.oracle.server
Sender: cjones@iron2-au
Newsgroups: comp.databases.oracle.server,comp.security.ssh,comp.terminals,comp.protocols.kermit.misc
Subject: Re: Strange behavior with SQLPLUS (Oracle)
References: <a8c29269.0301140753.7ee5175c@posting.google.com> <a8c29269.0301171317.2c874c13@posting.google.com>
From: Christopher.Jones@oracle.comX
Message-ID: <uhec4y4y5.fsf@oracle.comX>
Lines: 97
User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.2
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: 20 Jan 2003 12:40:02 +1100
NNTP-Posting-Host: 140.83.23.8
X-Trace: news.oracle.com 1043027198 140.83.23.8 (Sun, 19 Jan 2003 17:46:38 PST)
NNTP-Posting-Date: Sun, 19 Jan 2003 17:46:38 PST
Xref: newsmaster.cc.columbia.edu comp.databases.oracle.server:215391 comp.security.ssh:30868 comp.terminals:17752 comp.protocols.kermit.misc:14014
dba_222@yahoo.com (Roger Redford) writes:
If COLUMN has the effect you want, then I think it will be a
SQL*Plus issue.
Depending what part of your setup is "new", my guesses for
the cause are:
(i) a new version of the server optimizes buffer
allocations differently, or needs to cater for different
character sets. SQL functions like SUBSTR will display
different default column widths then you were used to.
(ii) Different Oracle NLS settings cause buffer
expansion.
Since your neighbor's terminal is OK then I would
triple-check your "copying environments" test.
Perhaps using the web based iSQL*Plus will help in general?
Because it uses HTML tables the browser does most of the
column resizing.
Chris
> Hi guys,
>
> Thanks for all your responses. With sqlplus I tried all these things:
> set trimspool on/off
> set linesize
> copying environments
>
> and it made no difference. I still had the same symptom.
>
> Only formatting the column works. Which, as I mentioned, is a lot
> more work for every ad hoc query.
>
> I'm thinking that this is really not a sqlplus issue, but a
> terminal issue. Any ideas?
>
> Thanks
>
>
>
> dba_222@yahoo.com (Roger Redford) wrote in message news:<a8c29269.0301140753.7ee5175c@posting.google.com>...
> > I've recently moved to a new environment, and I'm getting some strange
> > symptoms with sqlplus. The environment is:
> >
> > Oracle 9.2, on solaris
> > Ibm thinkpad laptop
> > Smarterm and Putty
> >
> > I've used both Smarterm and Putty to connect to unix and use sqlplus. It is
> > using SSH, but the symptoms occur whether I am just using telnet, or ssh.
> >
> >
> > The symptom is:
> >
> > When do I select some long columns, such as TABLE_OWNER,
> > OR table_name, the field takes up a whole line.
> >
> >
> > IE.
> >
> > Select table_owner ,
> > table_name ,
> > partition_name,
> > NUM_ROWS,
> > LAST_ANALYZED
> > from all_tab_partitions
> > where NUM_ROWS = 0
> > ORDER BY TABLE_OWNER,
> > TABLE_NAME,
> > PARTITION_NAME
> >
> >
> > I have tried:
> > set linesize 30000
> > substr(table_owner, 1, 20) as table_owner
> >
> > Yet, no matter what I do, the symptoms persist.
> >
> > Set wrap is on. If I set it off, I will only see the first field.
> >
> > The crazy thing is, that my neighbors' sqlplus works normally,
> > and only returns 30 or less columns.
> >
> >
> > Is there a setting that I should be concerned about? Is it in
> > sqlplus, or in the client software (Putty, or Smarterm)?
> >
> >
> > Thanks
--
Christopher Jones, Oracle Corporation, Australia.